VFPOLEDB is a 32 bit provider and is not recognized after installation as a
64-bit provider.
This thread was somewhat related, but no solution was offered. "Installing
foxpro oledb on SQL 2005 64 bit"
"Jim Mitten" <JimM...@discussions.microsoft.com> wrote in message
news:5577808D-E5BA-406E...@microsoft.com...
Does the 64bit ODBC driver access FoxPro? My earlier attempts using ODBC in
32-bit were not encouraging. It would sometimes work, but one large, complex
file kept locking up the system.
There must be a better way... Why isn't there a 64-bit shell on SQL that
allows you to use 32 bit ole with knowledge that there may be a slight
performance hit?.
Jim
"Gert E.R. Drapers" wrote:
> .
>
If there is a 64-bit ODBC driver for FoxPro, you could use 64-bit MSDASQL.
One option would be to write a wrapper in the CLR that uses OleDb Client.
Another is to install a 32-bit instance of SQL Server, and double
hop through it. Yes, that is really, really ugly.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx